<?php
###############   COPYLEFT GPLv3 LICENSE   ###############
##
## JFX Version 0.2.7
## Website Management Software
## www.jfxcms.com
##
## Copyright 2009 GPLv3 - http://www.opensource.org/licenses/gpl-3.0.html
##
## Anthony Gallon
## oi_antz@hotmail.com
##
## Permission is hereby granted to any person having a copy of this software
## to freely use and modify as required so long as the copyright notices
## and branding remain intact.
##
## Full license details available at http://www.jfxcms.com/license
##
###############   COPYLEFT GPLv3 LICENSE   ###############

$templateid = $DB->escape(get('template'));

$pageid = $SETTINGS->get('template_page_id');
$workspaceid = 1;

if($DB->countRows($CONFIG->dbprefix.'pages', "id = '{$pageid}'")==0){
    die('Error: '.$pageid.' ('.$id.') not found');
}
//$DB->debug(true);
$elements = $DB->fetchAll("SELECT * FROM {$CONFIG->dbprefix}blocks WHERE page_parent = 1 AND page_id = '{$pageid}' AND workspace_id = '{$workspaceid}' AND id = '{$templateid}' ORDER BY sorting ASC");
//$DB->debug(false);
$els = array();
foreach($elements as $k=>$v){
    $block = new JFX_Block;
    if(!$block->loadById($v['id'], '', true, true)) continue;
    $els[] = $block->__toJson();
}

$pData = $DB->fetchRow("SELECT * FROM {$CONFIG->dbprefix}pages WHERE id = '{$pageid}'");

$jsonString = '{';
$jsonString .= '"id" : "page-'.$pageid.'",
    "pageid" : "'.$pageid.'",
    "elements" : ['.implode(', ', $els).']';
$jsonString .= '}';

echo $jsonString;
exit;
